| 1. | Reverse key index cannot be used for range scan 回复:建了反向索引,为什么系统不使用索引了? |
| 2. | Indicates serializable range scan 指示可串行范围扫描。 |
| 3. | Close range scanning 近距离扫描 |
| 4. | This occurs rarely and only when a query plan has multiple range scans 这种情况发生的几率很小,仅当查询计划具有多次范围扫描时才会发生。 |
| 5. | If order by is required , eliminate the column that participates in the multiple range scans t . a in the example above from the order by clause 如果需要order by ,则通过order by子句清除参与多次范围扫描的列(如上面示例中的t . a ) 。 |
| 6. | Normally , the transact - sql query that generates such range scans has many between operators , each of which selects a range of rows from a table or an index 一般情况下,生成此类范围扫描的transact - sql查询包含许多between运算符,其中每个运算符会从表或索引中选择某一范围的行。 |